﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace DataMigration
{
    public partial class MigrationForm : Form
    {
        # region Private Properties

        private const string _connectionStringFrom = "Data Source=DREAMZ\\SQLEXPRESS;Initial Catalog=Sikra1;Persist Security Info=True;User ID=sa;Password=test";
        private const string _connectionStringTo = "Data Source=DREAMZ\\SQLEXPRESS;Initial Catalog=Sikra;Persist Security Info=True;User ID=sa;Password=test";

        private const string _selectPersons = @"SELECT [PersonID]
                                                  ,[Title]
                                                  ,[FirstName]
                                                  ,[LastName]
                                                  ,[EntryDate]
                                                  ,[CreateDate]
                                                  ,[ModifyDate]
                                              FROM [Sikra1].[dbo].[Persons]";

        private const string _selectAddresses = @"SELECT [AddressID]
                                                  ,[PersonID]
                                                  ,[AddressLine1]
                                                  ,[AddressLine2]
                                                  ,[AddressLine3]
                                                  ,[AddressLine4]
                                                  ,[PostalCode]
                                                  ,[Country]
                                                  ,[PhoneNumber]
                                                  ,[Email]
                                                  ,[CreateDate]
                                                  ,[ModifyDate]
                                              FROM [Sikra1].[dbo].[Address]";

        # endregion Private Properties

        # region Event Handlers

        public MigrationForm()
        {
            InitializeComponent();
        }

        private void buttonInvokeMigration_Click(object sender, EventArgs e)
        {

        }

        # endregion Event Handlers
    }
}
